INTRODUCTION:

Statistics and statistical analysis have become integral to pharmaceutical research and development, quality control, and regulatory compliance. Over the decades, the pharmaceutical industry has evolved from a fragmented sector focused on traditional remedies to a highly scientific and research-oriented field. This progress has been supported by increasingly sophisticated statistical methods and software tools enabling efficient data analysis and decision-making in both preclinical and clinical stages.^1-6

Statistical methods are employed across drug discovery, active pharmaceutical ingredient (API) development, drug product formulation, analytical method validation, clinical trial design, and quality control testing. Techniques such as Design of Experiments (DoE), multivariate analysis, regression modelling, and statistical process control (SPC) are extensively used to optimize formulation, manufacturing, and analytical methods.^1,3

Advancements in computing power have led to wide availability of statistical software tailored for pharmaceutical applications. Popular packages include Design-Expert for DOE, Minitab for general statistical analysis, SPSS for data management and complex testing, GraphPad Prism for scientific graphing and statistical tests, and R Studio for advanced data analysis and simulation. These tools facilitate various statistical procedures, from hypothesis testing and ANOVA to survival analysis and predictive modelling, enabling researchers to conduct analyses efficiently and reproducibly.^3-6

Fig 1: Statistical tools often use in pharma

Biostatistics provides the foundation for designing experiments, analysing preclinical toxicology data, and interpreting clinical trial outcomes. Rigorous statistical frameworks contribute to defining sample sizes, controlling errors, validating analytical methods, and assessing drug efficacy and safety in diverse populations. Increasingly, novel statistical models and software are integrated with emerging technologies such as machine learning and cloud computing to handle large and complex datasets in drug development.^4-6

IBM SPSS Statistical Software:

History, Role, And Usage:

History and Evolution:

SPSS, originally an acronym for Statistical Package for the Social Sciences, is a widely utilized and influential statistical tool for quantitative data analysis.⁷

Foundation:

The software was initially developed in 1968 at Stanford University by social scientist Norman H. Nie along with his two colleagues, Dale H. Bent and C. Hadlai Hull.⁷

Acquisition and Branding:

The company that created the software, SPSS Inc., was purchased by IBM in 2009. The brand name for the most recent versions is now IBM SPSS Statistics.⁸

Advancement:

Since its foundation, SPSS has advanced from a core statistical analysis tool to a major choice for researchers across different fields of study.⁷

2. Role in Analysis in the Pharma Field:

IBM SPSS Statistics plays a pivotal role in the healthcare and pharmaceutical industry by providing the statistical software needed to analyze complex data.⁸

Clinical Trials and Drug Development:

Statistical software like SPSS is used to analyze the data collected during clinical trials and prepare the final outcomes for regulatory submission. It is considered one of the most commonly used packages for statistical analysis in the industry.⁹

Healthcare Applications:

The software is employed across various sectors of the health industry, including the pharmaceutical industry, the biotechnology industry, medical devices, diagnostics, and the hospital industry.⁸

3. Benefits and Limitations:

IBM SPSS has emerged as a widely adopted and powerful tool whose importance cannot be overstated, as it suits the varied needs of researchers in fields including social science, health services, business, and education.¹⁰

User-Friendly Interface:

The software is highly popular due to its user-friendly interface^10-11 and better functional ability.¹¹

Analytical Capabilities:

It offers extensive analytical capabilities and strong statistical techniques,¹⁰ allowing researchers to perform sophisticated analyses without difficulty.^10-11

Data Management: Researchers rely on it to efficiently organize, process, and analyze data.¹⁰

Statistical Versatility: Its applications span descriptive statistics, inferential statistics, correlation, regression analysis, ANOVA, factor analysis, and non-parametric tests.¹¹

Limitations and Challenges:

Despite its effectiveness, users should be aware of certain challenges that persist in research practice.^10-11

Need for Expert Guidance:

Challenges such as the persistent need for expert guidance remain.¹⁰

Data Entry and Interpretation:

Other complexities include problems with data entry and the interpretation of results. ¹⁰

4. Step-by-Step Usage:

The process of using SPSS for analysis involves several key steps, generally divided into data preparation (Part 1) and statistical testing (Part 2).¹²

Step Action and Purpose Source:

1. Structuring Data: Determine the type of data you have gathered (e.g., Nominal/Ordinal/Interval/Ratio) and properly structure it for use in the software.

2. Entering and Saving: Input your data into the SPSS Data View window and save your work.

3. Descriptive Analysis: Begin with Part 1: Creating descriptive statistics and graphs. This involves looking at the data, exploring it, and generating basic summaries.

4. Visualisation: Create visual representations of the data, such as Histograms, Bar charts, Scatterplots (for correlation), Line graphs, and Pie charts.

5. Inferential Testing: Proceed to Part 2: Inferential Statistics. This involves testing hypotheses to draw conclusions about the wider population from your sample data.

6. Run Tests: Apply the appropriate tests based on your data type and what you are looking for (e.g., running a Parametric test, Non-parametric Test, Chi-Square Test, or Analysis of Variance - ANOVA).

7. Copying Output: After running the analysis, copy the output (which appears in a separate Output Viewer window) to other programs like MS Word for documentation and presentation of results.

MINITAB:

History and Evolution:

Minitab is a statistical software package developed in 1972 at Pennsylvania State University by Barbara F. Ryan, Thomas A. Ryan Jr., and Brian L. Joiner. It was initially created as a lighter alternative to the OMNITAB program developed by the National Institute of Standards and Technology.^13-14

Role in Statistical Analysis:

Minitab provides a broad range of statistical capabilities including hypothesis testing, regression (linear, nonlinear, logistic), analysis of variance (ANOVA), design of experiments (DOE), measurement system analysis, and quality tools such as control charts and capability analysis. It supports both exploratory data analysis and confirmatory analysis, enabling users to identify trends, test assumptions, optimize processes, and visualize data relationships effectively. Its ease of use makes statistical analysis accessible for beginners and powerful for experts.^13-15

Usefulness to Pharmaceutical Analysis:

Minitab is particularly useful in pharmaceutical analysis for process validation, quality control, stability studies, and formulation development. It aids in ensuring manufacturing processes meet regulatory requirements, including FDA process validation guidelines through stages like process design, qualification, and continued verification. Minitab helps pharmaceutical scientists identify key process variables, assess process capability, monitor product stability and shelf life, and improve product quality by providing robust statistical support.^13,16

Benefits to Pharmaceutical Statistical Analysis

· Identification and optimization of critical process variables for improved product quality.

· Root cause analysis to troubleshoot process failures and impurities.

· Enhanced visualization tools for clear communication of data and results.

· Support for rigorous method validation and compliance with regulatory standards.

· Facilitates Six Sigma and Lean methodologies for continuous process improvement.^13,14,16

Types of Statistical Analysis in Minitab:

Minitab supports a wide range of analyses, such as: Descriptive statistics and exploratory data analysis

Hypothesis testing: t-tests, chi-square, non-parametric tests

Regression analysis: linear, nonlinear, logistic ANOVA and multifactorial designs

Measurement system analysis (e.g. Gage RandR)

Design of experiments (DOE): Factorial, fractional factorial, response surface designs

Time series analysis and forecasting, Quality control charts (X-bar, R, S, P, NP, C, U charts).^13-15,17

Steps to Use Minitab:

· Data Input: Enter data directly or import from Excel, text files, or databases.

· Data Exploration: Use graphs (histograms, boxplots, scatterplots) and descriptive statistics to understand data distribution and detect issues.

· Choose Statistical Method: Select appropriate analysis such as hypothesis testing, regression, ANOVA, or DOE.

· Perform Analysis: Run analyses via menus or command line and review outputs.

· Interpret Results: Evaluate summary statistics, p-values, confidence intervals, and chart outputs.

· Graphical Visualization: Generate customized graphs for detailed data presentation.

· Reporting: Export results and graphs for documentation or publication.^14,18

SAS:

SAS stands for Statistical Analysis System and is a complete, comprehensive, and integrated platform for statistical analysis.¹⁹ It is described as more than just statistical software, offering modules for statistical analysis, data processing, spreadsheet management, and data creation. ^[19] Today, it is primarily known as a business intelligence and analytics tool.²⁰

It features a layered, multi-vendor architecture and provides extensive statistical capabilities for specialized and enterprise-wide analytical needs. ¹⁹

History and Evolution:

SAS originated from a statistical research institution, with its initial development steps funded by the National Health Institution.²⁰ The software has evolved to adapt to advances in industry standards like CDISC (Clinical Data Interchange Standards Consortium) and ICH (International Council for Harmonisation of Technical Requirements for Pharmaceuticals for Human Use), and modernization strategies such as electronic data capture ^21. The current version of SAS software is 9.4.²⁰

Type of Analysis in SAS:

SAS provides a comprehensive suite of analytical tools:

· Core Statistical Analysis: It includes a wide range of statistical analyses such as analysis of variance (ANOVA), regression analysis, and categorical data analysis.¹⁹

· Advanced Techniques: It supports multivariate analysis, survival analysis, psychometric analysis, cluster analysis, and nonparametric analysis.¹⁹

· Data Management: It is capable of managing, analyzing, visualizing, and reporting data in research settings.²¹ The software helps to check for potential errors, apply corrections, and combine batches into final analytic data sets.²²

· Specialized Analysis: Forecasting of economic variables with precision through time series data analysis is made possible by SAS.¹⁹

Role of SAS Software in Pharmacy and Pharmaceutical Analysis:

SAS is the industry standard in the pharmaceutical and healthcare sectors, particularly for clinical research and regulatory submission.²¹

· Regulatory Submission: The FDA (Food and Drug Administration) only accepts reports generated using SAS for regulatory submission. SAS plays a significant role from defining the clinical study up to the final regulatory submission.²¹

· Clinical Trials and Data Standards: Clinical SAS is used to generate reports that adhere to CDISC standards like SDTM (Study Data Tabulation Model) and ADAM (Analysis Data Model) to standardize and evaluate clinical trial data. The Statistical Analysis Plan (SAP) is created using Clinical SAS. ²¹

· Data Management and Quality: SAS is used to analyze and validate data before it is loaded into databases. It is essential for maintaining data quality and integrity by identifying and correcting erroneous or missing data.²²

· Drug Development: The SAS Drug Development solution supports the statistical analysis step of the Drug Development Process by merging the accessibility of the Internet with the Clinical Trials Workflow.²¹

Steps to Perform Analysis in SAS Software:

The steps to perform analysis in SAS software are executed through scripting language using DATA steps and PROC steps.²⁰

The process begins with Data Set Creation and Management, where raw data files are read, cleaned, and corrected to form a usable SAS data set using the DATA step.^20,22 This is a critical step for large prospective studies, as it ensures data quality and integrity by checking for errors, identifying missing data, and creating an essential audit trail for any changes.²²

Once the data is prepared, the next phase is the Execution of Analysis, which is performed by calling specific, pre-written analytical procedures known as the PROC step such as PROC REG or PROC GLM, along with the necessary parameters.^20,21 Following execution, the Viewing and Printing of Results occurs, where the output is displayed, which can be explicitly commanded using a procedure like proc print.¹⁹ Finally, the results are preserved through the Saving the Result step, where the user saves the project file and its contents, including the output log, for documentation and later reference.¹⁹

STATA Statistical Software:

Introduction, History, and Evolution:

Stata is a software package for statistical data analysis, which is being used to teach the fundamentals of biostatistics.²³ It is described as a versatile and flexible statistical package.²⁴

History and Versions:

Stata 10 was released in June 2007. It is noted for its powerful, versatile, and flexible nature, offering a wide range of user-friendly and accurate time series analytical and forecasting commands.²⁴ Stata Version 13 is the subject of a comprehensive guide for data analysis and interpretation, published in December 2022.^23-25

Steps to Analyze Data:

Data analysis using Stata, as documented in a comprehensive guide for Stata Version 13 ²⁵, involves a systematic process that covers data preparation, descriptive statistics, and inferential analysis:

· Data Management: This involves tasks such as generating files, sorting data, and calculating scores.²⁵

· Data Screening and Assumptions: Checking for underlying assumptions, which includes using tests such as the Shapiro Wilk test and the Skewness-kurtosis (S-K) test for assessing the normality of data].

· Descriptive Statistics: Calculating measures of central tendency, measures of dispersion, and assessing skewness and kurtosis.²⁵

· Modelling and Analysis: Performing various statistical tests and modelling, including simple linear regression, ANOVA, Spearman correlation, and Survival Analysis.²⁵

· Interpretation: Interpreting the outputs of these analyses, such as R-squared values in regression.²⁵

Importance and Use in Pharmaceutical Analysis:

Stata is highly valuable in the pharmaceutical and medical fields due to its comprehensive and advanced capabilities in biostatistics and evidence synthesis.

Foundation in Biostatistics:

Stata is used as the foundational software for teaching biostatistics to biomedical researchers.²³

Evidence Synthesis (Meta-analysis):

The software is widely used to perform statistical synthesis of research findings via meta-analysis to assess the relative effectiveness of competing interventions.²⁶ This is a core function for evaluating drugs and treatments.

Advanced Meta-analysis Tools:

The metaprop command is used to perform meta-analysis of binomial data (proportions).²⁷ The metapreg command offers advanced statistical procedures for performing meta-analysis, network meta-analysis, and meta-regression of binomial proportions using models like logistic and logistic-normal models.²⁸

Benefits:

Advanced Methods:

Stata possesses a broader range of advanced methods of data analysis compared to older, widely-used statistical packages.²³

Accessibility and Adoption:

Its increasing popularity in European universities and research institutions indicates its reliability and suitability for serious academic and research work.²³

Specialized Tools for Synthesis:

Stata's extensibility allows for advanced tools like metaprop²⁷ and metapreg^28, which are critical for the meta-analysis of binomial data (e.g., success rates, prevalence, etc.) in medical and public health research.

Limitations:

Cost: The price of some competing statistical software had "considerably increased in recent years," which resulted in institutions switching to Stata.²³This implies that Stata, despite being a viable alternative, is also a commercial product with associated costs (e.g., Stata/SE 10 corporate license was USD 1,795 in 2007).²⁴

Resource Availability:

The lack of awareness among the authors regarding Russian textbooks on the use of Stata in biomedical research suggests that resource availability and localized support might be a limitation in certain regions.²³

Microsoft Excel:

Microsoft Excel is a widely accessible and user-friendly tool that offers various features suitable for handling and analyzing research data in fields like biostatistics and pharmacy research.²⁹ In research, the accurate and efficient collection and preparation of data for analysis is a critical component.³⁰ Excel is commonly used for data entry because many medical researchers may have little or no training in dedicated data management tools, and almost every researcher is already familiar with the basics of Excel.³⁰

History and Evolution:

Microsoft Excel was first introduced in 1985 for the Macintosh and saw a Windows version released in 1987, rapidly becoming one of the most popular spreadsheet programs globally²⁹. The spreadsheet concept itself arose from the need to modify data using software and have the results derived from the analysis automatically update without the need to reprogram entire columns of calculation³². Over time, Excel has significantly evolved, integrating advanced features for data analysis, visualization, and integration with other software tools²⁹.

Types of Analysis to be Performed in Excel:

Excel's functionalities support data analysis across several stages of research, from preparation to advanced statistical procedures:

1. Data Management and Preparation:

Data Entry and Organization: Excel is widely used for data entry and manipulation, providing tools for organizing and managing large datasets.²⁹

Data Cleaning:

Techniques include removing duplicates and managing missing data via imputation or deletion²⁹.

Data Verification:

Simple guidelines, like using comparison formulas (e.g., IF(EXACT(...))), can be used to check if two data entry spreadsheets are identical, a strategy that helps ensure the data set accurately reflects the collected data and saves time on "cleaning" later ^[30].

Sorting and Filtering: Data can be organized in ascending or descending order, and displayed based on specific criteria²⁹.

2. Statistical and Inferential Analysis:

· Descriptive Statistics: Calculation of basic measures like mean, median, and mode^29,32.

· Hypothesis Testing: Functions for inferential statistics like the t-Test and the Chi-Square Test are available²⁹.

· Regression: It can be used for linear regression analysis using the LINEST function or the Regression tool in the Analysis ToolPak²⁹.

Statistical Analysis Related to Pharma Performed in Excel:

Excel is used for statistical analysis in clinical trials and research^29,31. Key statistical procedures available through Excel's built-in functions or the Analysis ToolPak include:

· Measures of Central Tendency: Mean (AVERAGE), Median (MEDIAN), Mode (MODE).^29,32

· Measures of Variability: Standard Deviation (STDEV.P, STDEV.S), Variance (VAR.P, VAR.S), Range.²⁹

· Inferential Tests: t-Test (T.TEST), Chi-Square Test (CHISQ.TEST), Correlation (CORREL).²⁹

· Relationship Modelling: Regression Analysis (LINEST or Analysis ToolPak).²⁹

· Systematic Review Tools: Meta-analysis (fixed-effect or random-effects models), Forest Plots.³³

How to Perform the Analysis:

· Data Structuring: Organize data with variables in columns and observations (cases) in rows, with clear labelling in the header row.²⁹

· Data Entry: Data can be entered manually or imported from external sources like databases.²⁹ Due to the potential for error, it's advised to create simple guidelines and strategies, such as having two people enter the data and then verifying the accuracy by comparing the spreadsheets.³⁰

· Calculation: Employ Excel's built-in statistical functions (e.g., AVERAGE, MEDIAN, STDEV) for basic calculations.²⁹

· Advanced Analysis: For more complex procedures like regression, the Analysis ToolPak add-in must be enabled through Excel Options.²⁹

· Meta-Analysis: Meta-analysis procedures, including the creation of Forest plots, are performed by constructing specific formulas in a dedicated spreadsheet using fixed-effect or random-effects models³³.

· Reporting: Use features like PivotTables and Pivot Charts to create interactive reports and summary tables to clearly present key findings ²⁹.

Applications in Pharma and Biostatistics:

Clinical Trials and Drug Development: It is used alongside other specialized software (like SPSS and MINITAB) to analyze collected data and prepare outcomes for regulatory submission in pharmaceutical industrial trials.³¹

Biostatistical Analysis and Literature Evaluation: Excel is useful for biostatistical analysis and literature evaluation for pharmacy students²⁹.

Systematic Reviews and Meta-Analysis:

Excel can be employed to conduct systematic reviews and meta-analyses to synthesize data from primary research³³.

Data Management:

It is widely used in medical research for data collection and proper organization, as its modifiability makes it easy to insert or modify previously collected data^30,32.

Design Expert:

Design-Expert software (or Design-Expert®) is a statistical application used for Design of Experiments (DoE)^34,35.

It serves as an optimization technique that addresses the drawbacks of traditional methods, like the "One Factor at a Time" (OFAT) approach, which is time-consuming, inefficient, and fails to describe factor interactions ^[34]. The use of this software helps researchers to reduce the number of trials, time, and costs.³⁴

Context:

It is categorized as one of the Quality by Design (QbD)-assisted software tools, along with others like Minitab and Modde®, that are used to implement the QbD approach in pharmaceutical development.³⁵

History and Evolution:

The application of Design-Expert stems from the need for a more efficient strategy, DoE, to overcome the limitations of the traditional OFAT approach, which demands a high number of experiments and fails to evaluate factor interactions^34,36. Design-Expert emerged as a leading computer-based DoE tool that provides predictive data and features to guide the researcher based on the experimental design being carried out³⁴.

Use in Pharmaceutical Analysis:

Design-Expert is fundamentally used as a critical optimization technique in pharmaceutical research to:

Determine Optimal Formulas:

It is used to establish the optimal mix of product or process attributes or select the best element/substance from a variety of choices.^34,45

Study Variables and Interactions:

It is crucial for understanding formulation variables, quality aspects, and the correlation between the independent variables (factors) and dependent variables (responses)^37,38. This includes evaluating the influence of formulation variables (e.g., polymer concentration) on key attributes (e.g., encapsulation efficacy, particle size) ³⁹.

Types of Statistical Analysis and How it is Performed:

The software implements the Design of Experiments (DoE) methodology, encompassing both design selection and statistical evaluation:

Screening Designs:

Used to efficiently identify the most significant factors affecting product quality. Designs include Two-level Full Factorial, Fractionate Factorial, and Plackett-Burman designs³⁶.

Optimization Designs (RSM):

Used to find the optimal settings for significant factors using Response Surface Methodology (RSM). Designs include Central Composite Designs (CCD) and Box-Behnken Designs (BBD)³⁶. BBD is noted as an active method for optimizing formulations.^36,37,45

Analysis of Variance (ANOVA):

Performed to determine the statistical significance of the regression model, the individual factors, and their interactions.^36,38

Multiple Regression Model:

Fitting The software fits a mathematical model to the experimental data. This involves checking regression significance, analyzing residuals, and calculating determination coefficients (R^2, R^2-adj, and R^2-pred), as well as the lack-of-fit of the model.^36,46

Optimization/Desirability:

Function Calculates and maximizes the desirability function to pinpoint the best combination of factor settings that simultaneously meet multiple response targets (e.g., maximizing percent dissolved while minimizing disintegration time).³⁸

Outputs:

The studies performed using Design-Expert software yield.

Predictive Models: Generation of mathematical equations that correlate independent variables (factors) with dependent variables (responses)^37,47.

Visual Response Analysis:

Creation of contour plots and 3D response surface designs to visually depict the relationship between factors and responses, aiding in understanding complex interactions^37,38.

Optimal Conditions:

The precise combination of factor settings predicted to yield the desired optimal product quality³⁸.

Model Validation Data:

Predicted values for an optimized batch, which are then compared to observed experimental values to validate the design and the reliability of the model.³⁷

Steps to Perform Analysis (Generalized DoE Process)

The general steps for performing an analysis utilizing the software within a DoE framework are:

· Define Variables: Identify the independent variables (factors, e.g., excipient concentration) and dependent variables (responses, e.g., particle size)^37,38.

· Select Experimental Design: Choose an appropriate design (e.g., Box-Behnken Design, Central Composite Design) based on the number of variables and the study objective (screening or optimization)^35-37

· Execute Experiments: Perform the trials as outlined by the design matrix generated by the software³⁷.

· Data Analysis: Input the experimental results into Design-Expert, which then performs ANOVA, fits a mathematical model, and generates plots^36,38.

· Optimization and Prediction: Use the generated model and the desirability function to predict the factor settings that achieve optimal results^37,38.

· Validation: Prepare a verification batch using the software's predicted optimal conditions to ensure that the observed results align with the predicted values, thus confirming the model's reliability³⁷.

Applications:

Design-Expert is widely applied for optimization in various pharmaceutical research areas:

Nano formulations:

Optimization of variables for nano-carrier systems, including biopolymer-based nanoparticles (e.g., 5-ASA-loaded)³⁷ and polymeric nanoparticles³⁸.

Advanced Drug Delivery Systems:

Optimization of liposomes and ethosomes³⁴.

QbD Implementation:

Its core methodology (DoE) is crucial for implementing the principles of Quality by Design (QbD) in both pharmaceutical and analytical development^5,36.

R Software:

R is an integrated suite of software facilities for data manipulation, calculation, and graphical display⁴⁰. It functions as both a language and software that is specifically designed to perform statistical analysis⁴¹. It allows users to perform factual examination and produce designs (statistical analysis and generating graphics) ⁴² and is characterized by: An effective data handling and storage facility⁴⁰. A well-developed, simple, and effective programming language (called 'S'), which supports conditionals, loops, and user-defined recursive functions⁴⁰. A large, coherent, and integrated collection of intermediate tools for data analysis⁴⁰. Graphical facilities for data analysis and display.⁴⁰

History and Evolution:

The development of R began in the early 1990s as a personal project by Ross Ihaka and Robert Gentleman at the University of Auckland, New Zealand^43,44.

Initial Design:

The developers aimed to combine useful features from two existing computer languages: S (developed at Bell Laboratories) and Scheme⁴⁴. The resulting language is very similar in appearance to S, but the underlying implementation and semantics are derived from Scheme⁴⁴.

Key Implementations:

The process involved altering the parser for S-like syntax, replacing a single scalar data type with the vector-based types of S, and adding the S concept of lazy arguments for functions ⁴⁴.

Widespread Distribution:

In 1996, the Comprehensive R Archive Network (CRAN) was created. CRAN began distributing the R statistical computing environment and its contributed packages widely on the Internet⁴³.

Core Team:

The R Core Team was founded in 1997 to guide the project's ongoing development⁴³.

Modern Status:

R has developed rapidly and is now recognized as the preeminent platform for developing free statistical software⁴³. It operates as an open-source free software environment within the GNU package⁴².

R Software's Role:

R's role extends beyond a simple calculation tool, positioning it as a fundamental environment for modern statistical practice:

Statistical Environment:

It serves as a comprehensive platform where a vast range of classical and modern statistical techniques have been implemented⁴⁰.

Free Software Platform:

It is the leading platform for developing and sharing free statistical software⁴³.

Data Analysis Climate:

For advanced users, its main appeal is its function as a programming climate fit to data analysis⁴². It also acts as a tool kit for standard statistical methods⁴².

Interactive Vehicle:

R is a primary tool for developing and implementing new methods of interactive data analysis⁴⁰.

How R Is Useful in Pharmaceutical Analysis:

R is useful in the pharmaceutical sector due to its power in handling complex data and modelling:

Bioassay Analysis:

R contains a specific capacity for Bioassay Analysis⁴³. Bioassays are essential studies in the industry for measuring the potency or concentration of a drug or substance.

Types of Analysis or Statistical Studies Carried Out:

R supports a comprehensive array of statistical and computational tasks:

Statistical Models:

· Linear models (lm ())^40.

· Generalized linear models (glm ())^40.

· Nonlinear least squares and maximum likelihood models^40.

· Analysis of variance (ANOVA)⁴⁰

· Robust regression and Additive models (available in packages)^40.

Hypothesis Testing and Comparisons:

· One- and two-sample tests^40.

· Model comparison^40.

Advanced Computational Methods:

· Time series analysis^41.

· Classification problems and machine learning^41.

Steps to Perform Analysis in R:

A statistical analysis using R is typically performed as a logical sequence of steps, where intermediate results are stored in objects for further use⁴⁰:

· Start R and Input Data:

Start R within a dedicated working directory (e.g., a subdirectory named work) to hold related files⁴⁰. Read large data objects from external files using functions like read. table (), often specifying options like header=TRUE⁴⁰.

· Perform Calculation and Modelling:

Issue R commands for vector arithmetic, array calculations, or statistical fitting^40. To fit a model, use functions such as lm() (for linear models), where the result is stored in a fit object (e.g., fitted.model <- lm(formula, data = data.frame))⁴⁰.

· Visualize Results:

Use R's powerful graphical facilities to analyze and display the data and results⁴⁰. Functions like plot () are used for high-level plotting⁴⁰.

· Exit and Save: Quit the R program using the command > q ()^40. The program prompts the user to save the data from the R session, which allows the user to make the work available in future sessions⁴⁰.

CONCLUSION:

Statistical tools have become indispensable to modern pharmaceutical research, advancing the rigor and reliability of scientific investigations. Among them, IBM SPSS and Stata simplify statistical modelling and clinical data evaluation, while Minitab and Design-Expert enhance process optimization and method validation under QbD and Six Sigma paradigms. SAS maintains its role as the regulatory benchmark for data submission and integrity, and R provides unmatched flexibility for complex modelling and open-access collaboration. The integration of these software systems enables evidence-based decision-making, efficient experimentation, and improved product quality throughout the drug development lifecycle.

ACKNOWLEDGMENT:

We extend our sincere gratitude to Dr. Mitali Dalwadi and Ria Patel for her invaluable guidance and mentorship throughout this research. Her insights and support were instrumental in the completion of this work.

REFERENCE:

1. Peterson JJ, Snee RD, McAllister PR, Schofield TL, Carella AJ. Statistics in pharmaceutical development and manufacturing. J Qual Technol. 2009; 41(2): 119-34.

2. Buncher CR, Tsay J, editors. Statistics in the pharmaceutical industry. 3rd ed. Boca Raton (FL): Chapman and Hall/CRC, Taylor and Francis Group; 2006.

3. Patel V, Patel D. Application of statistical tools in the development of pharmaceutical products. Int J Creat Res Thoughts. 2024; 12(4): e658-e668.

4. Joshi KP, Jamadar DC. Statistical software applications and statistical methods used in community medicine and public health research studies. Natl J Community Med. 2021. DOI: 10.5455/njcm.20210329094615.

5. Gowtham K, Surya prakash T, Nandhini R, Sineka P, Mohankumar S, Chidambar P, et al. Application of statistical software trends in real-world implementation within clinical and pre-clinical trials. J Popul Ther Clin Pharmacol. 2023; 30(5): 446-56.

6. Goyal AK, Saini J. Statistical analysis: A basic guide for pharmaceutical and bioscience researchers. J Pharm Biosci. 2023.

7. Rahman A, Muktadir MG. SPSS: An imperative quantitative data analysis tool for social science research. Int J Res Innov Soc Sci. 2021; 5(10).

8. Lahiri M. Healthcare management and future prospects using IBM SPSS Statistics. Trends Finance Econ. 2023;2(1):27-37.

9. Srivastav Y, Srivastav A, Singh J. Optimizing drug development using statistical software: Key components of pharma industrial trials. Int J Pharm Sci. 2024;2(7):1896-1911.

10. Jain P, Sengar S. Unraveling the role of IBM SPSS: A comprehensive examination of usage patterns, perceived benefits, and challenges in research practice. Educ Adm Theory Pract. 2024; 30(5): 9523-9530.

11. Yadav GS. Advancing social science research: a comprehensive review of SPSS applications and future directions. Cultural Commun Socialization J. 2024; 5(2): 50-3.

12. Garth A. Analysing data using SPSS (A practical guide for those unfortunate enough to have to actually do it). Sheffield (UK): Sheffield Hallam University; 2008.

13. Savale SK. Minitab: Statistical and process improvement software used in pharmaceuticals for data analysis. 2023.

14. Ganesh S. A review of Minitab - release 11. J Appl Math Decis Sci. 1997;1(1):73-8.

15. Minitab, LLC. Minitab statistical software: prepare your students for the data-driven world ahead. 2019.

16. Zhou J, Zhao Y. Application of Minitab-based Six Sigma to improve functional circuit test throughput rates. In: The 2022 International Conference on Innovation and Sustainable Development (ICISD 2022). Singapore: Springer Nature Singapore; 2023. p. 1-6.

17. Okagbue HI, Obasi EC, Ohaneme IM, Ihediwa CC. Trends and usage pattern of SPSS and Minitab software in scientific research. J Phys Conf Ser. 2021; 1734:012017.

18. Ramesh NI. The role of Minitab in teaching and learning statistics. MSOR Connect. 2009;9(3):9-14.

19. Sharma L, Mehta Ranka N. SAS: a complete, comprehensive and integrated platform for statistical analysis. Raj J Extn Edu. 2012; 20:108-11.

20. Marasinghe MG, Koehler KJ. Statistical data analysis using SAS. 2nd edn. London: Springer; 2018.

21. Ranpise S, Kharat A. Exploration of Drug Discovery and Clinical SAS. Int J Creat Res Thoughts (IJCRT). 2023;11(7).

22. Kruse RL, Mehr DR. Data management for prospective research studies using SAS® software. BMC Med Res Methodol. 2008; 8:61.

23. Unguryanu TN, Grjibovski AM. Introduction to stata - Software for statistical data analysis. Ekologiya Cheloveka (Human Ecology). 2014; 1.

24. Yaffee RA. Stata 10 (Time Series and Forecasting). J Stat Softw. 2007;23(Software Review 1).

25. Islam MT, Kabir R, Nisha M, editors. Data Analysis with Stata: A Comprehensive Guide for Data Analysis and Interpretation of Outputs. First ed. Dhaka, Bangladesh: Altaf Publications; 2022.

26. Chaimani A, Mavridis D, Salanti G. A hands-on practical tutorial on performing meta-analysis with Stata. Evid Based Ment Health. 2014;17(4):111-6.

27. Nyaga VN, Arbyn M, Aerts M. Metaprop: a Stata command to perform meta-analysis of binomial data. Arch Public Health. 2014; 72:39.

28. Nyaga VN, Arbyn M. Methods for meta-analysis and meta-regression of binomial data: concepts and tutorial with Stata command metapreg. Arch Public Health. 2024; 82: 14.

29. Gettman D. Using MS Excel to Analyze Research Data [Presentation]. D'Youville College: Special Presentation for Biostatistics and Literature Evaluation (PMD708); 2010 Oct 6.

30. Elliott AC, Hynan LS, Reisch JS, Smith JP. Preparing Data for Analysis Using Microsoft Excel. J Investig Med. 2006; 54(6): 334-41.

31. Srivastav Y, Srivastav A, Singh J. Optimizing Drug Development Using Statistical Software: Key Components of Pharma Industrial Trials. Int J Pharm Sci. 2024; 2(7): 1896-1911.

32. Divisi D, Di Leonardo G, Zaccagna G, Crisci R. Basic statistics with Microsoft Excel: a review. J Thorac Dis. 2017; 9(6): E511-E514.

33. Neyeloff JL, Fuchs SC, Moreira LB. Meta-analyses and Forest plots using a Microsoft Excel spreadsheet: step-by-step guide focusing on descriptive data analysis. BMC Res Notes. 2012; 5:52.

34. Sopyan I, Gozali D, Sriwidodo, Guntina RK. Design-Expert software (DOE): an application tool for optimization in pharmaceutical preparations formulation. Int J App Pharm. 2022; 14(4): 57-63.

35. Dofe PS, Wadher SJ, Lakhmale SS, Bodke DA. Differnet Types of Software Used in Quality by Design. Int J Creat Res Thoughts. 2024; 12(9): a417-a423.

36. Fukuda IM, Pinto CFF, Moreira CDS, Saviano AM, Lourenço FR. Design of Experiments (DoE) applied to Pharmaceutical and Analytical Quality by Design (QbD). Braz J Pharm Sci. 2018; 54(4): e000001006.

37. Akram W, Garud N. Design expert as a statistical tool for optimization of 5-ASA-loaded biopolymer-based nanoparticles using Box Behnken factorial design. Future J Pharm Sci. 2021; 7:146.

38. Challa TR, Reshma K. Experimental Design Statistically by Design Expert Software: A Model Poorly Soluble Drug with Dissolution Enhancement and Optimization. Res J Pharm Technol. 2022;15(8):3677-3680.

39. Koliqi R, Breznica P, Daka A, Koshi B. Application of Design of Expert software for evaluating the influence of formulation variables on the encapsulation efficacy, drug content and particle size of PEO-PPO-PEO/Poly (DL-lactide-co-caprolactone) nanoparticles as carriers for SN-38. Med Pragensia. 2021; 58(2): 101-108.

40. Venables WN, Smith DM, R Core Team. An Introduction to R: Notes on R: A Programming Environment for Data Analysis and Graphics. Version 4.5.1 (2025-06-13). [Internet]. Vienna: R Foundation for Statistical Computing; 2025.

41. Mestiri S. How to use the R software. MPR-online. 2019 Mar.

42. Asere GF, Iseyemi OS. The Needs to Embrace R Programming Language in Every Organizations That Deals with Statistical Research and Data Analysis. IRE J. 2022 Jan; 5(7).

43. Fox J, Leanage A. R and the Journal of Statistical Software. J Stat Softw. 2016 Sep; 73(2).

44. Ihaka R, Gentleman R. R: A Language for Data Analysis and Graphics. J Comput Graph Stat. 1996; 5(3): 299–314.

45. Kaustubh Jagtap, Bharati Chaudhari, Vivekkumar Redasani. Quality by Design (QbD) concept Review in Pharmaceuticals. Asian Journal of Research in Chemistry. 2022; 15(4):303-7.

46. Vrushali R. Kadam, M. P. Patil, Vrushali V. Pawar, Sanjay Kshirsagar. A Review on: Quality by Design (QbD). Asian J. Res. Pharm. Sci. 2017; 7(4): 197-204.

47. Lucky B. Vasave, Mayur S. Bhamare, Rushikesh L. Bachhav, Shivraj P. Jadhav, Sunil K. Mahajan. Quality by Design (QBD) in Pharmaceutical Development: A Review of Principles and Case Studies. Research Journal of Pharmaceutical Dosage Forms and Technology.2025; 17(3): 203-1

Received on 22.02.2026 Revised on 27.03.2026

Accepted on 29.04.2026 Published on 27.05.2026

Available online from May 30, 2026

Asian J. Research Chem.2026; 19(3):270-279.

DOI: 10.52711/0974-4150.2026.00042

This work is licensed under a Creative Commons Attribution-Non Commercial-Share Alike 4.0 International License. Creative Commons License.